package hotel.switchs.oversea.online.mapper;

import hotel.base.oversea.repository.MyMapper;
import hotel.switchs.oversea.api.VO.SwitchRoomPriceAndStatusVo;
import hotel.switchs.oversea.api.entity.SwitchHotelRoomPriceAndStatusLogEntity;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * @Auther: lmf
 * @Date: 2021/01/28/14:37
 * @Description:
 */
public interface SwitchHotelRoomPriceAndStatusLogMapper extends MyMapper<SwitchHotelRoomPriceAndStatusLogEntity> {
    /**
     * 建表
     * @param createTabelSql
     */
    @Update("${createTabelSql}")
    void createTable(@Param("createTabelSql") String createTabelSql);

    Integer insertData(@Param("tableName") String tableName, @Param("list") List<SwitchHotelRoomPriceAndStatusLogEntity> switchHotelRoomPriceAndStatusLogEntities);

    List<SwitchRoomPriceAndStatusVo> getRoomPriceAndStatusList(Integer roomId, Integer mtGoodId, String date, List<String> weeks);
}
